When a scheduled job executes using Microsoft Excel, you might find that the Excel executable is still running in the background after the job has finished. This problem will most likely occur after scheduling a job using the SAS^® Add-in for Microsoft Office 2.1.0.1009 or later (hot fix 21AMO11 or later).

To circumvent this problem, you can set a configuration option that will end the Excel.exe after the scheduled job has finished. To set this option, follow these steps:

1. Close all Microsoft Office applications on the client machine.
2. Create a file named SAS.OfficeAddin.dll.config, if it does not already exist, and place it in the installation location of the SAS Add-In.

For release 2.1, the default location is:

<drive>:\Program Files\SAS\Add-In for Microsoft Office\

For release 4.2, the default location is:

<drive>:\Program Files\SAS\Add-InforMicrosoftOffice\4.2\

3. Edit the SAS.OfficeAddin.dll.config as described next.

If this is a new file, add the following lines:

<configuration>
    <assemblySettings> 
        <add key="ForceGarbageCollection" value="true"/>
    </assemblySettings> 
</configuration> 

If this file already exists, then add a key line to the existing file inside the assemblySettings tag:

<add key="ForceGarbageCollection" value="true"/>
    

4. Save the file.

Now, when you run a scheduled job, the Excel application will close when the job ends.

Operating System and Release Information